This document will show you how to create aggregate/contingency tables, maps, and other visualizations using 2009 public use NHTS Data. (Download here: http://nhts.ornl.gov/download.shtml)

# load packages
library(data.table)
library(magrittr) # Not required for analysis, but helpful.

# source code
source('make_table.R')
source('table_add_ons.R')
source('html_tools.R')
source('util.R')

Reading and Merging the Data

The first step is to read in the data. Due to the size of the csvs, we will read in only necessary columns using data.table’s fread function. We will then merge the weights with the survey data using unique identifiers.

# There are 100 replicate weight names. Use get_wgt_names to create the vector of names.
wgt_names <- get_wgt_names('DAYWGT')

# Read in the two necessary datasets
per50wt <- fread('./data/2009/per50wt.csv', select = c('HOUSEID','PERSONID',wgt_names))
## 
Read 3.2% of 308901 rows
Read 9.7% of 308901 rows
Read 16.2% of 308901 rows
Read 22.7% of 308901 rows
Read 29.1% of 308901 rows
Read 35.6% of 308901 rows
Read 42.1% of 308901 rows
Read 48.6% of 308901 rows
Read 55.0% of 308901 rows
Read 61.5% of 308901 rows
Read 68.0% of 308901 rows
Read 74.5% of 308901 rows
Read 80.9% of 308901 rows
Read 87.4% of 308901 rows
Read 93.9% of 308901 rows
Read 308901 rows and 103 (of 305) columns from 0.780 GB file in 00:00:25
DAYV2PUB <- fread('./data/2009/DAYV2PUB.csv',select = c('HOUSEID','PERSONID','HHFAMINC','VMT_MILE','HHSTATE'))
## 
Read 70.2% of 1167321 rows
Read 1167321 rows and 5 (of 112) columns from 0.410 GB file in 00:00:03
# Set the appropriate unique identifiers for merging
setkeyv(per50wt, c('HOUSEID','PERSONID'))
setkeyv(DAYV2PUB, c('HOUSEID','PERSONID'))

# merge the datasets
dt <- DAYV2PUB[per50wt, nomatch=0]

Creating Aggregate Tables

We will use the make_table function to create weighted aggregate tables. Frequency, Sum, and Average are currently supported.

1. Number of trips by derived total household income.

ex1 <- make_table(
  data = dt, 
  agg = 'count',
  factors = 'HHFAMINC',
  wgt_name = 'DAYWGT'
)

head(ex1)
##    HHFAMINC      DAYWGT        se
## 1:       -9    79639127  33105123
## 2:       -8  4436710423 414424912
## 3:       -7 13298239233 531043751
## 4:        1  6702099743 580334130
## 5:        2 11533717689 722938310
## 6:        3 16177362235 769493361

2. Sum of driver vehicle miles by state

ex2 <- make_table(
  data = dt, 
  agg = 'sum',
  agg_var = 'VMT_MILE',
  factors = 'HHSTATE',
  wgt_name = 'DAYWGT',
  subset = 'VMT_MILE >= 0' # Include subset condition. We do not want to calculate missing (-7,-8,-9) responses.
)

head(ex2)
##    HHSTATE     VMT_MILE         se
## 1:      AK   3475329956  492576810
## 2:      AL  43072636132 4444398457
## 3:      AR  19994532357 1967096788
## 4:      AZ  49266095910 6007566860
## 5:      CA 230190486224 3285485469
## 6:      CO  39170169246 4261683727

3. Average driver vehicle miles by state and derived total household income

ex3 <- make_table(
  data = dt, 
  agg = 'avg',
  agg_var = 'VMT_MILE',
  factors = c('HHSTATE','HHFAMINC'),
  wgt_name = 'DAYWGT',
  subset = 'VMT_MILE >= 0',
  variance = 'moe' #Option to get Margin of Error, instead of default Standard Error
)

head(ex3)
##    HHSTATE HHFAMINC VMT_MILE       moe
## 1:      AK       -8 7.641531  3.442652
## 2:      AK       -7 9.761131  5.996204
## 3:      AK        2 8.671024  8.861375
## 4:      AK        3 3.061442  1.998055
## 5:      AK        4 6.953211 13.674062
## 6:      AK        5 3.674938  6.996312

Creating HTML Aggregate/Contingency Tables

1. HTML table without variance displayed

make_contingency_table(ex3, show_variance = F) %>%
  format_table %>% 
  make_html_table
HHFAMINC -9 -8 -7 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
HHSTATE
AK 0.0000 7.6415 9.7611 0.0000 8.6710 3.0614 6.9532 3.6749 16.0907 4.6921 5.4653 4.5613 6.7338 2.7192 5.1440 2.8301 4.5102 5.3279 7.2795 8.2586 6.4716
AL 0.0000 7.5301 11.5908 14.0406 34.4716 3.7726 9.6009 17.7478 9.4484 11.8305 12.4375 18.1849 9.4145 4.4484 11.1167 9.6416 11.7801 6.1230 14.1704 10.4900 10.3939
AR 0.0000 7.0380 9.0933 10.4454 16.5966 7.2315 6.0990 3.8017 10.1404 8.5753 8.9612 9.5662 9.4126 9.8041 7.9410 18.4542 9.9558 7.9804 7.8885 9.4726 13.1849
AZ 0.0000 2.9468 7.3169 6.9776 18.7289 6.9391 4.4152 5.7754 8.7257 6.0261 11.3939 9.8182 9.0141 7.8668 14.8468 9.8119 8.6402 6.8135 9.3846 17.9475 8.3395
CA 16.3414 8.5543 8.1510 10.3712 8.4714 8.0044 7.2037 7.2628 8.7828 7.6730 8.3936 8.0233 9.0212 8.7788 9.1168 9.3935 9.4056 8.3065 8.8770 9.7435 9.6913
CO 0.0000 3.0250 12.3733 9.2000 4.4410 7.9977 4.0366 15.5535 4.9114 17.3812 10.2745 3.2998 5.6457 18.3290 5.5010 10.5431 7.7655 9.1096 7.9284 8.5656 10.1965
CT 0.0000 4.1868 13.5257 2.6667 6.7048 9.8789 11.3014 8.3169 4.0266 4.0878 9.0903 13.8542 31.6306 8.1235 7.4090 5.3916 10.6401 3.1383 5.3041 9.9019 13.2467
DC 0.0000 8.4433 10.3489 0.0000 3.0000 2.3854 4.3223 4.3995 8.1224 3.1890 6.5814 11.9768 6.6064 3.7701 24.0549 5.0723 6.5763 3.7222 3.5901 7.4984 5.5125
DE 0.0000 50.5187 6.4003 0.0000 4.4296 0.7625 4.4799 14.1210 6.9528 10.9468 4.4106 8.0913 5.2344 59.5415 12.7233 9.5342 8.8610 14.0637 7.6462 8.8041 11.7910
FL 7.2033 9.1914 9.1371 6.6163 6.1110 6.5198 7.3927 8.0158 8.4556 9.1168 7.9884 8.7404 9.1507 9.0282 10.9026 8.9050 9.6044 10.2090 9.7653 10.2058 9.9579
GA 0.0000 15.7238 9.4611 10.9593 12.5521 9.2004 9.5964 9.1867 9.4389 13.1777 16.2498 9.2498 9.1894 9.1007 11.9152 12.5995 8.8939 12.3302 11.9475 11.3177 12.8807
HI 0.0000 5.0395 11.1333 1.4439 7.5685 8.5570 8.6896 3.6169 7.3063 6.8270 4.5733 2.5239 5.7533 3.8256 5.3664 3.2286 7.1706 6.0068 6.3465 5.5635 6.8842
IA 3.0000 6.5208 10.0158 30.3062 8.3122 6.3517 5.6331 7.3669 6.9069 9.4469 7.7191 12.0419 7.5997 9.5535 8.0617 6.5388 6.7256 8.4385 9.9307 8.5020 9.9264
ID 3.4016 6.0063 12.6751 16.9791 3.9715 5.7593 7.0389 31.7611 8.3222 8.4325 6.0079 7.3135 11.5646 10.5898 9.5543 2.6258 4.8426 6.5571 7.3930 6.6206 7.8888
IL 0.0000 6.6053 7.6677 4.2159 8.3825 3.6322 12.4091 7.0132 6.4036 7.3215 5.5886 6.0817 7.1897 7.6229 8.4978 7.1650 8.0793 7.1840 9.2014 9.7325 9.3598
IN 0.0000 6.4646 7.3909 5.9286 7.2406 7.0505 5.5475 6.6873 8.3576 7.5172 9.9274 8.8012 8.1994 9.0986 8.9586 8.0587 11.0063 9.3285 9.0443 10.9217 10.7146
KS 0.0000 18.4954 4.1250 1.0168 2.8712 9.3264 6.2646 38.2337 4.6307 4.8312 10.3218 4.0665 5.3968 6.8686 11.4034 4.4843 20.3446 5.3957 4.5577 14.6528 12.2108
KY 0.0000 10.1980 5.7776 10.9922 13.9300 16.5340 8.3153 5.9722 11.8980 7.4411 8.9091 20.9760 8.9830 13.2109 8.6736 19.0252 10.4644 8.6407 6.6519 7.7591 8.5107
LA 0.0000 5.0095 11.5223 2.2463 6.4596 10.7457 4.4312 4.6940 9.2008 5.9482 5.3175 4.4399 10.1942 9.7410 8.7033 14.3867 8.7391 10.3232 17.6573 16.5281 14.9957
MA 0.0000 4.0833 9.7099 5.8983 14.8289 5.9640 4.4539 4.2199 7.1168 10.1197 11.8155 7.8150 10.9009 5.6638 6.2611 23.1748 7.9996 11.2395 15.0721 15.0483 11.1532
MD 0.0000 8.5427 13.6245 1.8519 6.9625 1.7809 5.1645 6.0790 18.1198 8.0536 11.9931 6.8660 14.4037 6.4574 7.9682 10.8011 13.3939 5.6741 17.6171 10.5729 14.8895
ME 0.0000 7.7754 3.2083 0.2222 7.8534 8.8337 8.9394 6.5832 4.9920 4.6855 9.6736 17.8201 10.6318 18.6272 16.3436 5.3350 5.4655 9.3668 15.4956 12.3133 8.6186
MI 0.0000 11.0243 15.3822 6.1228 4.2801 6.0489 6.8643 7.8136 5.4496 10.0197 6.9515 6.8965 12.7939 4.9193 8.7550 13.4944 7.8040 5.1189 9.0210 11.3258 8.6800
MN 0.0000 2.1474 6.4553 4.2520 4.5376 2.2905 5.6659 4.2519 9.5218 9.0932 5.3617 9.8684 9.5411 10.9148 9.9892 4.3567 7.3277 15.1589 7.9707 8.5595 12.1282
MO 0.0000 3.1232 9.8763 0.0000 10.6528 10.9799 15.2261 13.3868 5.6478 8.1963 5.5982 10.5745 8.7684 4.2235 7.6873 10.1486 10.1066 8.5832 10.0387 9.1907 17.3607
MS 0.0000 5.8456 4.7428 21.5445 11.2585 8.3016 17.2245 8.5572 6.6141 14.1638 8.0847 103.6009 10.5150 37.2763 10.0150 6.0359 6.9634 22.2836 20.0459 6.8151 11.9442
MT 0.0000 4.0572 8.2897 3.6685 0.9206 4.1657 14.2916 6.3656 5.3687 8.4202 26.1168 5.8988 6.5863 9.7086 9.8946 7.4359 19.6896 12.6768 6.5269 9.6484 26.9798
NC 10.0000 6.2550 8.9589 6.0982 8.1016 8.6577 8.8186 9.6854 9.7957 9.2454 9.2717 12.8170 11.1220 10.1203 11.2256 9.9604 11.6255 13.9336 11.8257 10.6951 11.5034
ND 4.5000 0.6667 4.7726 8.9831 3.5694 9.8632 9.1720 3.7327 6.2366 4.2980 3.6801 7.5803 10.9094 6.2307 6.8728 2.4152 15.8942 17.7348 16.6316 8.9371 5.7216
NE 6.5660 8.8191 6.4454 8.1993 6.6960 7.0680 4.9266 7.8100 12.3171 7.5380 8.3981 9.6753 8.5493 6.5478 13.6453 6.3738 9.8366 12.4340 7.4366 11.3192 10.0474
NH 0.0000 2.2593 11.1807 1.4209 6.4766 8.2386 8.4760 5.7842 8.2985 17.5550 14.4369 13.3610 18.0320 9.9693 7.8926 6.4387 10.6572 7.8865 10.2263 10.8490 12.3625
NJ 0.0000 7.9881 9.1182 3.3875 3.3333 262.8067 2.5313 8.5121 6.2691 4.3036 6.7950 7.1482 11.4965 10.3294 13.3344 6.5336 6.9988 12.7355 13.4452 8.0273 10.4469
NM 0.0000 2.7280 13.0181 23.1865 5.2640 6.1161 2.5720 5.4144 7.2209 5.6762 6.8490 10.0465 15.1832 28.2829 7.8088 4.5383 3.1193 7.3126 5.3984 8.2497 19.1609
NV 0.0000 8.0444 5.8762 3.2500 11.6877 4.3373 4.4893 2.7401 7.3786 6.4491 6.3839 8.7265 11.8404 11.7382 7.0077 36.4788 8.5003 9.2080 6.2107 7.7584 10.8052
NY 6.8704 6.5187 8.6748 12.5151 5.8043 6.1318 7.5479 6.9818 6.8410 7.6337 7.8156 6.8407 9.8649 7.4193 8.4316 8.5553 8.9231 14.9466 8.5221 8.4554 9.4272
OH 0.0000 33.6085 27.1134 1.6191 9.6160 9.5768 5.3853 9.7222 9.5231 20.4840 9.3050 9.8026 6.6659 27.9566 7.8051 9.0384 9.6530 14.6686 11.0625 12.2542 7.3503
OK 0.0000 6.4254 28.1849 16.9093 14.2566 9.1205 6.7927 7.2364 7.5292 9.7217 6.3139 10.3085 7.8289 18.0822 3.8643 9.0324 3.0611 5.6391 11.4973 8.9363 12.2854
OR 0.0000 4.4222 6.5150 0.5556 2.7900 3.5151 6.0604 17.0545 4.4118 4.9109 7.0725 10.5935 7.7010 6.5596 5.6485 23.0060 9.1089 14.7325 4.4128 7.2134 8.1598
PA 4.2724 4.6536 10.9572 8.0693 10.2926 7.5329 8.6098 6.1705 5.7408 10.1664 5.9283 7.4869 13.9561 10.7881 10.8508 10.2243 10.3891 7.1990 8.8464 12.5702 10.0487
RI 0.0000 3.2832 7.4096 0.0000 56.7634 2.9603 3.3112 4.0348 3.9528 3.9538 7.1987 2.0463 5.2759 7.6762 9.3750 17.8533 2.0497 6.8556 9.8391 11.7035 11.5140
SC 8.8730 9.1928 9.0483 6.2046 6.3214 9.6374 11.0878 9.3678 10.5364 12.7906 9.6516 7.9806 9.9618 9.8489 9.2276 13.8016 11.9901 10.3631 12.4002 11.2115 10.3298
SD 2.0000 8.0030 21.3545 9.4321 4.2393 2.8135 4.2628 18.9588 9.9843 8.0735 7.0688 8.7537 7.9029 10.6755 9.8901 5.5056 6.7612 10.4256 5.3584 6.4111 10.7663
TN 0.2222 6.6380 16.5333 7.2052 6.7597 6.5601 8.2283 11.9356 10.9718 11.6906 9.9551 13.3103 9.0375 13.4982 10.6205 12.8168 14.0690 10.5271 11.9017 9.9185 10.8957
TX 8.1459 10.8888 11.6670 7.4577 8.1177 9.1266 8.2685 8.5910 8.0932 9.4565 8.4322 10.2108 8.7350 10.2003 11.3832 10.8093 9.7822 9.7075 11.5267 11.0154 11.1365
UT 0.0000 7.7915 3.2061 16.7416 0.0000 3.7229 8.2743 9.5167 33.1498 1.7287 4.0551 10.6927 6.7825 7.1244 5.8736 7.8082 4.2967 6.6708 8.8819 8.6688 7.3493
VA 5.6891 10.6051 10.1814 10.8780 8.7703 8.7579 10.7496 9.0254 9.4091 11.4759 10.7410 9.4328 9.6033 9.7994 9.0434 9.4621 11.1173 9.5568 11.1305 10.1877 10.0743
VT 8.7143 5.1364 10.2969 22.3570 6.7345 9.6337 6.0779 7.1504 7.4487 9.9361 11.7653 7.4199 7.8429 11.6723 11.6894 10.7960 11.2696 11.1435 10.9076 10.1618 10.4590
WA 0.0000 3.6230 16.8673 7.9466 2.8646 9.9742 6.0416 6.7809 4.7221 22.0090 10.2386 7.3690 8.3343 6.7718 14.3258 3.9635 7.9939 6.7342 6.9491 10.4722 9.1177
WI 0.0000 8.2163 6.9116 19.1345 6.6401 7.4065 10.0250 6.4420 7.8819 14.4299 8.1153 8.4286 8.6607 11.1477 9.6775 13.3483 10.8149 10.2514 10.0787 10.6085 10.2501
WV 0.0000 7.2415 6.0528 7.3011 6.7213 7.5823 8.9582 12.9597 13.1620 10.9161 11.2057 12.5817 7.9540 12.7558 20.1805 15.9753 14.5605 5.7276 10.7585 16.7615 12.3385
WY 0.0000 0.0000 3.1706 0.6190 2.9580 1.7193 2.6533 5.3132 7.4934 8.2084 10.7206 5.9978 4.6181 11.9584 8.7587 5.0098 8.0880 19.3201 4.4484 10.5897 11.1173

2. HTML table with variance displayed

make_contingency_table(ex3) %>%
  format_table %>% 
  make_html_table
VMT_MILE moe
HHSTATE HHFAMINC
AK -9 0.0000 0.0000
-8 7.6415 3.4427
-7 9.7611 5.9962
1 0.0000 0.0000
2 8.6710 8.8614
3 3.0614 1.9981
4 6.9532 13.6741
5 3.6749 6.9963
6 16.0907 7.9121
7 4.6921 2.5123
8 5.4653 3.0940
9 4.5613 1.3134
10 6.7338 4.4413
11 2.7192 0.8923
12 5.1440 1.8665
13 2.8301 0.8483
14 4.5102 1.0725
15 5.3279 1.5434
16 7.2795 3.1642
17 8.2586 7.8624
18 6.4716 0.9668
AL -9 0.0000 0.0000
-8 7.5301 2.8394
-7 11.5908 3.9861
1 14.0406 12.7004
2 34.4716 40.6891
3 3.7726 1.6255
4 9.6009 5.2449
5 17.7478 5.7716
6 9.4484 4.4200
7 11.8305 5.7763
8 12.4375 3.4205
9 18.1849 14.9090
10 9.4145 5.9967
11 4.4484 0.8309
12 11.1167 3.3763
13 9.6416 6.4064
14 11.7801 4.5625
15 6.1230 0.8356
16 14.1704 16.1775
17 10.4900 4.3328
18 10.3939 2.4123
AR -9 0.0000 0.0000
-8 7.0380 6.1872
-7 9.0933 1.7591
1 10.4454 51.9934
2 16.5966 10.9081
3 7.2315 5.0872
4 6.0990 4.9233
5 3.8017 0.5280
6 10.1404 6.4023
7 8.5753 1.5556
8 8.9612 2.5511
9 9.5662 2.7205
10 9.4126 4.0901
11 9.8041 3.7102
12 7.9410 5.6189
13 18.4542 18.6954
14 9.9558 4.8387
15 7.9804 5.2642
16 7.8885 4.3317
17 9.4726 2.0853
18 13.1849 11.1391
AZ -9 0.0000 0.0000
-8 2.9468 0.6833
-7 7.3169 3.1690
1 6.9776 4.2401
2 18.7289 6.6613
3 6.9391 5.0835
4 4.4152 3.2397
5 5.7754 1.8400
6 8.7257 7.3185
7 6.0261 4.0348
8 11.3939 6.9688
9 9.8182 7.7536
10 9.0141 2.7943
11 7.8668 2.7640
12 14.8468 13.0993
13 9.8119 5.9119
14 8.6402 2.6420
15 6.8135 2.4127
16 9.3846 8.9620
17 17.9475 18.7096
18 8.3395 2.0400
CA -9 16.3414 63.8372
-8 8.5543 2.5965
-7 8.1510 0.6884
1 10.3712 3.7065
2 8.4714 2.2931
3 8.0044 1.2831
4 7.2037 1.4876
5 7.2628 1.5111
6 8.7828 2.2716
7 7.6730 0.9274
8 8.3936 0.8448
9 8.0233 1.0117
10 9.0212 0.9302
11 8.7788 1.1163
12 9.1168 1.0127
13 9.3935 2.3909
14 9.4056 0.8317
15 8.3065 1.2818
16 8.8770 1.0257
17 9.7435 0.7986
18 9.6913 0.4053
CO -9 0.0000 0.0000
-8 3.0250 4.7284
-7 12.3733 6.1883
1 9.2000 0.0000
2 4.4410 1.5587
3 7.9977 4.1012
4 4.0366 0.5596
5 15.5535 3.1546
6 4.9114 4.5556
7 17.3812 19.8284
8 10.2745 5.7660
9 3.2998 1.4301
10 5.6457 1.5024
11 18.3290 28.4032
12 5.5010 5.3992
13 10.5431 8.2996
14 7.7655 3.6172
15 9.1096 3.0356
16 7.9284 4.2177
17 8.5656 2.3571
18 10.1965 1.8989
CT -9 0.0000 0.0000
-8 4.1868 1.3238
-7 13.5257 9.2265
1 0.0000 0.0000
2 6.7048 5.5950
3 9.8789 4.6329
4 11.3014 19.8980
5 8.3169 2.0253
6 4.0266 1.6073
7 4.0878 0.9593
8 9.0903 9.8032
9 13.8542 4.9334
10 31.6306 27.5909
11 8.1235 6.1775
12 7.4090 3.9645
13 5.3916 4.0638
14 10.6401 2.5192
15 3.1383 1.6295
16 5.3041 1.1425
17 9.9019 3.3352
18 13.2467 3.3860
DC -9 0.0000 0.0000
-8 8.4433 0.2221
-7 10.3489 15.4304
1 0.0000 0.0000
2 0.0000 0.0000
3 2.3854 0.8596
4 4.3223 0.9323
5 4.3995 1.8986
6 8.1224 6.3690
7 3.1890 0.8473
8 6.5814 7.6009
9 11.9768 19.1121
10 6.6064 4.0811
11 3.7701 1.6832
12 24.0549 13.0004
13 5.0723 0.2669
14 6.5763 10.4639
15 3.7222 1.6320
16 3.5901 2.1655
17 7.4984 5.3882
18 5.5125 2.5661
DE -9 0.0000 0.0000
-8 50.5187 33.9917
-7 6.4003 4.0643
1 0.0000 0.0000
2 4.4296 0.5177
3 0.7625 1.6874
4 4.4799 6.4323
5 14.1210 8.5744
6 6.9528 6.5959
7 10.9468 3.6512
8 4.4106 1.3763
9 8.0913 2.9318
10 5.2344 1.9396
11 59.5415 118.7915
12 12.7233 6.0519
13 9.5342 5.2752
14 8.8610 4.9153
15 14.0637 52.8975
16 7.6462 2.5025
17 8.8041 8.1632
18 11.7910 2.1793
FL -9 7.2033 7.9021
-8 9.1914 2.6296
-7 9.1371 2.6270
1 6.6163 1.8556
2 6.1110 1.1769
3 6.5198 0.7350
4 7.3927 0.8869
5 8.0158 0.9378
6 8.4556 1.0139
7 9.1168 1.0129
8 7.9884 0.9839
9 8.7404 1.3146
10 9.1507 0.9336
11 9.0282 1.9166
12 10.9026 2.6349
13 8.9050 1.1204
14 9.6044 1.2535
15 10.2090 2.0964
16 9.7653 1.0504
17 10.2058 1.1775
18 9.9579 0.7502
GA -9 0.0000 0.0000
-8 15.7238 10.6528
-7 9.4611 1.1108
1 10.9593 4.5390
2 12.5521 5.8298
3 9.2004 2.2342
4 9.5964 2.0797
5 9.1867 2.5416
6 9.4389 1.8106
7 13.1777 8.7044
8 16.2498 6.2607
9 9.2498 3.2074
10 9.1894 1.8515
11 9.1007 2.7238
12 11.9152 3.3618
13 12.5995 4.2732
14 8.8939 1.6067
15 12.3302 3.6460
16 11.9475 3.4780
17 11.3177 1.5239
18 12.8807 3.2467
HI -9 0.0000 0.0000
-8 5.0395 0.8401
-7 11.1333 4.5999
1 1.4439 5.0512
2 7.5685 7.9172
3 8.5570 3.7727
4 8.6896 7.4037
5 3.6169 5.6873
6 7.3063 3.8288
7 6.8270 10.5161
8 4.5733 3.0946
9 2.5239 1.8036
10 5.7533 1.3876
11 3.8256 0.9285
12 5.3664 2.6752
13 3.2286 0.2776
14 7.1706 3.5366
15 6.0068 0.7930
16 6.3465 4.1004
17 5.5635 1.9637
18 6.8842 1.4643
IA -9 0.0000 0.0000
-8 6.5208 1.9120
-7 10.0158 2.8124
1 30.3062 53.3537
2 8.3122 4.5351
3 6.3517 3.3338
4 5.6331 1.6600
5 7.3669 2.6141
6 6.9069 2.1773
7 9.4469 3.9290
8 7.7191 2.2582
9 12.0419 4.3952
10 7.5997 2.5884
11 9.5535 2.1758
12 8.0617 1.0719
13 6.5388 1.3400
14 6.7256 1.4457
15 8.4385 1.9311
16 9.9307 3.0573
17 8.5020 1.3375
18 9.9264 2.1875
ID -9 0.0000 0.0000
-8 6.0063 1.5844
-7 12.6751 8.9168
1 0.0000 0.0000
2 3.9715 4.6102
3 5.7593 7.3547
4 7.0389 4.3233
5 31.7611 48.4322
6 8.3222 5.0513
7 8.4325 6.1230
8 6.0079 1.6698
9 7.3135 2.0058
10 11.5646 4.5641
11 10.5898 13.4555
12 9.5543 4.3661
13 2.6258 0.8887
14 4.8426 0.6350
15 6.5571 2.9121
16 7.3930 4.0594
17 6.6206 3.1776
18 7.8888 2.3749
IL -9 0.0000 0.0000
-8 6.6053 10.4537
-7 7.6677 3.2007
1 4.2159 3.2981
2 8.3825 6.0037
3 3.6322 1.5995
4 12.4091 5.9851
5 7.0132 3.4866
6 6.4036 2.4809
7 7.3215 2.9957
8 5.5886 2.1420
9 6.0817 3.5275
10 7.1897 3.0393
11 7.6229 3.7273
12 8.4978 1.4208
13 7.1650 3.0823
14 8.0793 2.1251
15 7.1840 2.4116
16 9.2014 3.5968
17 9.7325 2.2251
18 9.3598 1.6051
IN -9 0.0000 0.0000
-8 6.4646 1.6946
-7 7.3909 1.3832
1 5.9286 4.9701
2 7.2406 4.3856
3 7.0505 2.1356
4 5.5475 1.4358
5 6.6873 1.2585
6 8.3576 1.6888
7 7.5172 2.2004
8 9.9274 1.7658
9 8.8012 1.8333
10 8.1994 1.3361
11 9.0986 2.7239
12 8.9586 1.6170
13 8.0587 1.5417
14 11.0063 2.7950
15 9.3285 1.6661
16 9.0443 1.5154
17 10.9217 1.4463
18 10.7146 1.3774
KS -9 0.0000 0.0000
-8 18.4954 28.0241
-7 4.1250 3.7767
1 1.0168 3.6016
2 2.8712 6.6497
3 9.3264 8.2464
4 6.2646 1.7245
5 38.2337 36.5437
6 4.6307 1.6124
7 4.8312 2.4484
8 10.3218 9.8297
9 4.0665 6.7664
10 5.3968 4.2800
11 6.8686 4.7621
12 11.4034 5.3790
13 4.4843 4.6573
14 20.3446 11.0558
15 5.3957 1.9658
16 4.5577 2.9316
17 14.6528 5.4113
18 12.2108 6.2897
KY -9 0.0000 0.0000
-8 10.1980 7.8860
-7 5.7776 1.2801
1 10.9922 12.4797
2 13.9300 8.8096
3 16.5340 12.1758
4 8.3153 4.3830
5 5.9722 6.0918
6 11.8980 3.4858
7 7.4411 7.1696
8 8.9091 5.1808
9 20.9760 30.2734
10 8.9830 3.9673
11 13.2109 6.8062
12 8.6736 3.2172
13 19.0252 18.5556
14 10.4644 6.8457
15 8.6407 7.4415
16 6.6519 0.8367
17 7.7591 3.7625
18 8.5107 2.1686
LA -9 0.0000 0.0000
-8 5.0095 4.4235
-7 11.5223 16.9916
1 2.2463 0.1830
2 6.4596 4.0899
3 10.7457 5.9540
4 4.4312 1.9264
5 4.6940 2.8708
6 9.2008 5.3394
7 5.9482 1.8442
8 5.3175 3.0496
9 4.4399 1.0935
10 10.1942 6.3489
11 9.7410 10.8960
12 8.7033 3.3668
13 14.3867 5.9456
14 8.7391 2.4405
15 10.3232 5.3519
16 17.6573 4.9916
17 16.5281 13.5684
18 14.9957 8.0933
MA -9 0.0000 0.0000
-8 4.0833 1.5230
-7 9.7099 3.3373
1 5.8983 9.9106
2 14.8289 6.9015
3 5.9640 4.7962
4 4.4539 2.3209
5 4.2199 1.6873
6 7.1168 5.9912
7 10.1197 4.9140
8 11.8155 13.8392
9 7.8150 6.1243
10 10.9009 4.2858
11 5.6638 3.9404
12 6.2611 2.3490
13 23.1748 30.2842
14 7.9996 4.6170
15 11.2395 1.8856
16 15.0721 11.0313
17 15.0483 6.2782
18 11.1532 3.1535
MD -9 0.0000 0.0000
-8 8.5427 1.2433
-7 13.6245 8.0836
1 1.8519 0.0000
2 6.9625 7.9351
3 1.7809 1.7681
4 5.1645 2.8396
5 6.0790 3.3516
6 18.1198 1.9103
7 8.0536 7.0493
8 11.9931 7.3357
9 6.8660 2.1131
10 14.4037 9.1370
11 6.4574 8.8538
12 7.9682 1.8203
13 10.8011 7.2095
14 13.3939 7.2276
15 5.6741 5.7957
16 17.6171 11.9169
17 10.5729 4.2984
18 14.8895 3.9375
ME -9 0.0000 0.0000
-8 7.7754 7.4472
-7 3.2083 2.7627
1 0.0000 0.0000
2 7.8534 3.7186
3 8.8337 3.5360
4 8.9394 4.0949
5 6.5832 6.5302
6 4.9920 1.7033
7 4.6855 0.9437
8 9.6736 3.7949
9 17.8201 11.7127
10 10.6318 7.3197
11 18.6272 7.9120
12 16.3436 5.7145
13 5.3350 2.4750
14 5.4655 4.4689
15 9.3668 4.5302
16 15.4956 7.0284
17 12.3133 7.2009
18 8.6186 2.9591
MI -9 0.0000 0.0000
-8 11.0243 13.0099
-7 15.3822 8.5667
1 6.1228 0.7485
2 4.2801 4.3180
3 6.0489 1.5718
4 6.8643 3.1857
5 7.8136 2.6620
6 5.4496 1.8779
7 10.0197 5.7639
8 6.9515 2.0945
9 6.8965 1.9940
10 12.7939 5.1579
11 4.9193 0.8953
12 8.7550 2.2334
13 13.4944 7.4295
14 7.8040 1.9030
15 5.1189 1.7092
16 9.0210 4.2336
17 11.3258 5.9944
18 8.6800 1.3897
MN -9 0.0000 0.0000
-8 2.1474 0.8653
-7 6.4553 1.7590
1 4.2520 4.0760
2 4.5376 1.7843
3 2.2905 1.5014
4 5.6659 1.4367
5 4.2519 3.0141
6 9.5218 6.9531
7 9.0932 4.3926
8 5.3617 2.1528
9 9.8684 6.2815
10 9.5411 5.4736
11 10.9148 4.9113
12 9.9892 5.4611
13 4.3567 4.8519
14 7.3277 5.4511
15 15.1589 14.3935
16 7.9707 2.9619
17 8.5595 1.7768
18 12.1282 3.1579
MO -9 0.0000 0.0000
-8 3.1232 8.2951
-7 9.8763 9.6703
1 0.0000 0.0000
2 10.6528 3.9570
3 10.9799 9.0067
4 15.2261 38.2998
5 13.3868 16.0977
6 5.6478 3.3558
7 8.1963 2.1139
8 5.5982 2.6478
9 10.5745 4.9648
10 8.7684 4.1518
11 4.2235 2.2375
12 7.6873 5.0276
13 10.1486 12.1976
14 10.1066 1.9924
15 8.5832 3.4149
16 10.0387 2.8934
17 9.1907 3.5837
18 17.3607 16.3709
MS -9 0.0000 0.0000
-8 5.8456 21.7700
-7 4.7428 1.5272
1 21.5445 8.4564
2 11.2585 13.3647
3 8.3016 3.0648
4 17.2245 10.9689
5 8.5572 5.9791
6 6.6141 3.4862
7 14.1638 6.7103
8 8.0847 6.1395
9 103.6009 69.6475
10 10.5150 2.7548
11 37.2763 122.7441
12 10.0150 2.6043
13 6.0359 7.3182
14 6.9634 1.4038
15 22.2836 17.2566
16 20.0459 19.9493
17 6.8151 2.9426
18 11.9442 4.7599
MT -9 0.0000 0.0000
-8 4.0572 0.2184
-7 8.2897 5.8441
1 3.6685 4.5162
2 0.9206 0.0963
3 4.1657 1.7515
4 14.2916 16.1182
5 6.3656 15.5150
6 5.3687 1.9081
7 8.4202 4.9135
8 26.1168 34.1796
9 5.8988 3.7336
10 6.5863 6.0028
11 9.7086 5.3557
12 9.8946 7.7416
13 7.4359 1.6333
14 19.6896 33.4493
15 12.6768 18.5017
16 6.5269 2.6805
17 9.6484 6.3437
18 26.9798 29.5254
NC -9 0.0000 0.0000
-8 6.2550 1.1285
-7 8.9589 1.4022
1 6.0982 1.5721
2 8.1016 1.8257
3 8.6577 2.3145
4 8.8186 2.6652
5 9.6854 2.7854
6 9.7957 1.5160
7 9.2454 2.0115
8 9.2717 1.0786
9 12.8170 3.1187
10 11.1220 2.0422
11 10.1203 2.0677
12 11.2256 1.8222
13 9.9604 1.6393
14 11.6255 2.6220
15 13.9336 5.9898
16 11.8257 2.0363
17 10.6951 1.6072
18 11.5034 3.2699
ND -9 4.5000 0.0000
-8 0.0000 0.0000
-7 4.7726 4.3735
1 8.9831 13.5683
2 3.5694 3.2235
3 9.8632 1.5243
4 9.1720 7.7129
5 3.7327 2.4976
6 6.2366 2.6846
7 4.2980 1.0716
8 3.6801 1.1857
9 7.5803 11.1033
10 10.9094 10.5398
11 6.2307 7.4835
12 6.8728 3.9199
13 2.4152 2.0829
14 15.8942 5.2018
15 17.7348 8.1405
16 16.6316 12.5332
17 8.9371 4.3560
18 5.7216 2.0570
NE -9 6.5660 5.1715
-8 8.8191 6.9981
-7 6.4454 3.9012
1 8.1993 9.4842
2 6.6960 7.2923
3 7.0680 9.4693
4 4.9266 2.5816
5 7.8100 3.7106
6 12.3171 12.8712
7 7.5380 1.8129
8 8.3981 3.5159
9 9.6753 3.1312
10 8.5493 2.1341
11 6.5478 2.7057
12 13.6453 8.0098
13 6.3738 2.6305
14 9.8366 3.4337
15 12.4340 13.2845
16 7.4366 3.6487
17 11.3192 6.0152
18 10.0474 2.6367
NH -9 0.0000 0.0000
-8 0.0000 0.0000
-7 11.1807 3.2577
1 1.4209 0.6254
2 6.4766 1.0102
3 8.2386 74.5818
4 8.4760 4.0766
5 5.7842 8.7155
6 8.2985 3.1001
7 17.5550 21.5739
8 14.4369 14.3293
9 13.3610 15.3598
10 18.0320 28.8146
11 9.9693 3.4866
12 7.8926 2.7170
13 6.4387 2.2379
14 10.6572 6.3465
15 7.8865 3.6553
16 10.2263 5.6405
17 10.8490 2.5686
18 12.3625 2.4552
NJ -9 0.0000 0.0000
-8 7.9881 3.2563
-7 9.1182 3.8362
1 3.3875 0.2240
2 0.0000 0.0000
3 262.8067 73.8465
4 2.5313 1.4870
5 8.5121 6.9720
6 6.2691 4.5462
7 4.3036 0.9490
8 6.7950 3.0430
9 7.1482 4.9048
10 11.4965 3.7080
11 10.3294 2.5601
12 13.3344 13.5334
13 6.5336 4.9536
14 6.9988 2.1645
15 12.7355 3.7331
16 13.4452 17.1249
17 8.0273 2.0188
18 10.4469 2.2623
NM -9 0.0000 0.0000
-8 2.7280 3.9846
-7 13.0181 19.8758
1 23.1865 34.2942
2 5.2640 2.3570
3 6.1161 7.0235
4 2.5720 2.6392
5 5.4144 2.6913
6 7.2209 5.1699
7 5.6762 2.4272
8 6.8490 3.9736
9 10.0465 4.4831
10 15.1832 12.9962
11 28.2829 37.6993
12 7.8088 3.4419
13 4.5383 3.3838
14 3.1193 4.0581
15 7.3126 0.4512
16 5.3984 2.2111
17 8.2497 5.3880
18 19.1609 11.4568
NV -9 0.0000 0.0000
-8 8.0444 0.0000
-7 5.8762 2.6351
1 3.2500 0.0000
2 11.6877 4.5437
3 4.3373 1.6630
4 4.4893 1.4191
5 2.7401 4.8772
6 7.3786 3.3255
7 6.4491 0.4462
8 6.3839 3.4883
9 8.7265 18.8517
10 11.8404 9.1220
11 11.7382 5.2844
12 7.0077 3.1885
13 36.4788 39.8279
14 8.5003 2.8153
15 9.2080 3.2260
16 6.2107 1.5414
17 7.7584 3.4639
18 10.8052 3.4883
NY -9 6.8704 10.5382
-8 6.5187 1.8753
-7 8.6748 0.8105
1 12.5151 4.8106
2 5.8043 1.2438
3 6.1318 1.4063
4 7.5479 1.2080
5 6.9818 1.1388
6 6.8410 1.5891
7 7.6337 1.3465
8 7.8156 1.2689
9 6.8407 0.9159
10 9.8649 1.2539
11 7.4193 1.0291
12 8.4316 1.2236
13 8.5553 1.4504
14 8.9231 1.4627
15 14.9466 10.8358
16 8.5221 1.1571
17 8.4554 0.6504
18 9.4272 0.9597
OH -9 0.0000 0.0000
-8 33.6085 37.8735
-7 27.1134 43.6087
1 1.6191 15.9577
2 9.6160 2.8486
3 9.5768 8.4001
4 5.3853 3.2890
5 9.7222 3.3253
6 9.5231 3.1162
7 20.4840 17.4514
8 9.3050 2.5280
9 9.8026 1.8331
10 6.6659 2.1372
11 27.9566 44.7100
12 7.8051 3.5018
13 9.0384 1.9048
14 9.6530 3.6582
15 14.6686 7.9466
16 11.0625 3.6672
17 12.2542 4.8834
18 7.3503 1.2362
OK -9 0.0000 0.0000
-8 0.0000 0.0000
-7 28.1849 50.7156
1 16.9093 5.1220
2 14.2566 3.1827
3 9.1205 7.2790
4 6.7927 2.7760
5 7.2364 13.3798
6 7.5292 1.1968
7 9.7217 13.3366
8 6.3139 3.0326
9 10.3085 5.1012
10 7.8289 3.7711
11 18.0822 14.1945
12 3.8643 1.3853
13 9.0324 3.3238
14 3.0611 1.0990
15 5.6391 2.7456
16 11.4973 16.9322
17 8.9363 4.8821
18 12.2854 8.8733
OR -9 0.0000 0.0000
-8 0.0000 0.0000
-7 6.5150 3.0315
1 0.0000 0.0000
2 2.7900 2.4463
3 3.5151 2.4103
4 6.0604 2.1473
5 17.0545 23.2860
6 4.4118 2.3903
7 4.9109 4.6374
8 7.0725 3.7067
9 10.5935 2.9021
10 7.7010 3.5137
11 6.5596 3.5748
12 5.6485 1.2880
13 23.0060 11.1036
14 9.1089 3.8623
15 14.7325 18.0600
16 4.4128 1.7221
17 7.2134 1.5685
18 8.1598 6.2659
PA -9 0.0000 0.0000
-8 4.6536 2.0568
-7 10.9572 3.0119
1 8.0693 8.1888
2 10.2926 14.9515
3 7.5329 4.0649
4 8.6098 5.4050
5 6.1705 1.5603
6 5.7408 1.6011
7 10.1664 8.4175
8 5.9283 2.3810
9 7.4869 2.7338
10 13.9561 10.1690
11 10.7881 4.1197
12 10.8508 5.4949
13 10.2243 3.0631
14 10.3891 11.7921
15 7.1990 3.3249
16 8.8464 1.5464
17 12.5702 3.4728
18 10.0487 2.6287
RI -9 0.0000 0.0000
-8 3.2832 2.0443
-7 7.4096 11.7046
1 0.0000 0.0000
2 56.7634 4.1115
3 2.9603 3.0356
4 3.3112 1.9707
5 4.0348 2.4757
6 3.9528 0.9157
7 3.9538 6.1671
8 7.1987 8.4407
9 2.0463 0.9237
10 5.2759 2.1603
11 7.6762 1.9539
12 9.3750 3.2150
13 17.8533 6.6749
14 2.0497 1.2168
15 6.8556 7.2772
16 9.8391 4.3826
17 11.7035 6.0355
18 11.5140 3.9561
SC -9 8.8730 0.0000
-8 9.1928 2.3641
-7 9.0483 3.1977
1 6.2046 2.1627
2 6.3214 1.4298
3 9.6374 1.9494
4 11.0878 3.4162
5 9.3678 2.0871
6 10.5364 3.6134
7 12.7906 2.3644
8 9.6516 1.5225
9 7.9806 1.6505
10 9.9618 2.0536
11 9.8489 1.4068
12 9.2276 1.5654
13 13.8016 4.6656
14 11.9901 2.3327
15 10.3631 1.7218
16 12.4002 2.3878
17 11.2115 1.2398
18 10.3298 1.6704
SD -9 2.0000 0.0000
-8 8.0030 4.9794
-7 21.3545 24.9076
1 9.4321 3.5765
2 4.2393 4.4983
3 2.8135 1.9748
4 4.2628 1.5291
5 18.9588 19.5519
6 9.9843 7.6179
7 8.0735 6.9869
8 7.0688 2.7307
9 8.7537 8.2935
10 7.9029 4.1450
11 10.6755 7.9225
12 9.8901 3.0075
13 5.5056 2.0855
14 6.7612 1.3307
15 10.4256 3.9781
16 5.3584 2.0608
17 6.4111 1.9053
18 10.7663 2.9359
TN -9 0.0000 0.0000
-8 6.6380 1.5528
-7 16.5333 12.9587
1 7.2052 3.5135
2 6.7597 1.6292
3 6.5601 1.1501
4 8.2283 1.9543
5 11.9356 4.3469
6 10.9718 3.5579
7 11.6906 2.5778
8 9.9551 2.3451
9 13.3103 7.2338
10 9.0375 1.6803
11 13.4982 3.5437
12 10.6205 2.1506
13 12.8168 6.2934
14 14.0690 6.1925
15 10.5271 3.8732
16 11.9017 1.7228
17 9.9185 1.7997
18 10.8957 1.5037
TX -9 8.1459 11.2932
-8 10.8888 2.4659
-7 11.6670 2.7811
1 7.4577 2.0102
2 8.1177 1.1786
3 9.1266 1.4020
4 8.2685 0.8704
5 8.5910 1.4506
6 8.0932 0.7981
7 9.4565 1.7487
8 8.4322 0.6993
9 10.2108 1.7369
10 8.7350 0.6756
11 10.2003 1.5440
12 11.3832 2.4021
13 10.8093 2.5449
14 9.7822 0.9612
15 9.7075 1.5080
16 11.5267 1.6502
17 11.0154 0.9104
18 11.1365 0.8787
UT -9 0.0000 0.0000
-8 7.7915 16.3008
-7 3.2061 2.5169
1 0.0000 0.0000
2 0.0000 0.0000
3 3.7229 1.3914
4 8.2743 3.1593
5 9.5167 4.3796
6 33.1498 53.6559
7 1.7287 5.9708
8 4.0551 2.7066
9 10.6927 2.7327
10 6.7825 4.5202
11 7.1244 4.6248
12 5.8736 1.6429
13 7.8082 4.3613
14 4.2967 2.6550
15 6.6708 1.8645
16 8.8819 6.3143
17 8.6688 2.9552
18 7.3493 3.8916
VA -9 5.6891 4.4019
-8 10.6051 3.6421
-7 10.1814 3.2288
1 10.8780 4.4046
2 8.7703 4.2906
3 8.7579 1.4907
4 10.7496 1.9890
5 9.0254 2.0297
6 9.4091 1.4626
7 11.4759 1.4740
8 10.7410 1.4708
9 9.4328 1.1870
10 9.6033 1.1499
11 9.7994 1.1141
12 9.0434 0.8902
13 9.4621 1.7689
14 11.1173 1.4233
15 9.5568 1.9931
16 11.1305 1.6007
17 10.1877 1.0110
18 10.0743 0.7831
VT -9 8.7143 0.0000
-8 5.1364 1.6794
-7 10.2969 2.9455
1 22.3570 19.8412
2 6.7345 2.6431
3 9.6337 4.0116
4 6.0779 1.6641
5 7.1504 1.8524
6 7.4487 1.7946
7 9.9361 2.2113
8 11.7653 2.7965
9 7.4199 2.7351
10 7.8429 1.5357
11 11.6723 4.3162
12 11.6894 4.6097
13 10.7960 3.3492
14 11.2696 2.4421
15 11.1435 7.0571
16 10.9076 2.8339
17 10.1618 1.7525
18 10.4590 1.5649
WA -9 0.0000 0.0000
-8 3.6230 1.0621
-7 16.8673 5.2304
1 7.9466 1.8864
2 2.8646 1.2941
3 9.9742 4.6457
4 6.0416 3.5684
5 6.7809 3.2784
6 4.7221 1.7525
7 22.0090 29.5841
8 10.2386 3.2723
9 7.3690 4.1561
10 8.3343 2.4071
11 6.7718 2.5521
12 14.3258 14.3087
13 3.9635 1.2275
14 7.9939 3.0128
15 6.7342 1.6279
16 6.9491 2.5723
17 10.4722 4.4288
18 9.1177 1.7247
WI -9 0.0000 0.0000
-8 8.2163 6.1899
-7 6.9116 2.1413
1 19.1345 10.2414
2 6.6401 2.4223
3 7.4065 4.7053
4 10.0250 7.5802
5 6.4420 1.9544
6 7.8819 2.4937
7 14.4299 6.2596
8 8.1153 2.2418
9 8.4286 4.2341
10 8.6607 1.9588
11 11.1477 3.5639
12 9.6775 2.0397
13 13.3483 6.5143
14 10.8149 3.3406
15 10.2514 4.5552
16 10.0787 2.9147
17 10.6085 2.2926
18 10.2501 1.5195
WV -9 0.0000 0.0000
-8 7.2415 10.0289
-7 6.0528 3.4285
1 7.3011 2.8425
2 6.7213 1.0646
3 7.5823 3.5322
4 8.9582 5.7135
5 12.9597 8.9052
6 13.1620 4.8173
7 10.9161 10.3906
8 11.2057 6.9594
9 12.5817 10.8949
10 7.9540 2.7165
11 12.7558 8.2046
12 20.1805 17.9692
13 15.9753 12.0776
14 14.5605 7.9890
15 0.0000 0.0000
16 10.7585 8.9316
17 16.7615 7.7492
18 12.3385 10.1312
WY -9 0.0000 0.0000
-8 0.0000 0.0000
-7 3.1706 1.2479
1 0.6190 0.0000
2 2.9580 1.7794
3 1.7193 0.8334
4 2.6533 1.2072
5 5.3132 4.6360
6 7.4934 5.9682
7 8.2084 6.6280
8 10.7206 5.3146
9 5.9978 2.7271
10 4.6181 1.9053
11 11.9584 6.4001
12 8.7587 9.9594
13 5.0098 1.6259
14 8.0880 5.8880
15 19.3201 15.0697
16 4.4484 4.4768
17 10.5897 7.1129
18 11.1173 4.7241

3. HTML table with row totals

make_contingency_table(ex3, show_variance = F) %>%
  add_totals(margin = 1) %>%
  format_table %>% 
  make_html_table
HHFAMINC -9 -8 -7 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
HHSTATE
AK 0.0000 7.6415 9.7611 0.0000 8.6710 3.0614 6.9532 3.6749 16.0907 4.6921 5.4653 4.5613 6.7338 2.7192 5.1440 2.8301 4.5102 5.3279 7.2795 8.2586 6.4716
AL 0.0000 7.5301 11.5908 14.0406 34.4716 3.7726 9.6009 17.7478 9.4484 11.8305 12.4375 18.1849 9.4145 4.4484 11.1167 9.6416 11.7801 6.1230 14.1704 10.4900 10.3939
AR 0.0000 7.0380 9.0933 10.4454 16.5966 7.2315 6.0990 3.8017 10.1404 8.5753 8.9612 9.5662 9.4126 9.8041 7.9410 18.4542 9.9558 7.9804 7.8885 9.4726 13.1849
AZ 0.0000 2.9468 7.3169 6.9776 18.7289 6.9391 4.4152 5.7754 8.7257 6.0261 11.3939 9.8182 9.0141 7.8668 14.8468 9.8119 8.6402 6.8135 9.3846 17.9475 8.3395
CA 16.3414 8.5543 8.1510 10.3712 8.4714 8.0044 7.2037 7.2628 8.7828 7.6730 8.3936 8.0233 9.0212 8.7788 9.1168 9.3935 9.4056 8.3065 8.8770 9.7435 9.6913
CO 0.0000 3.0250 12.3733 9.2000 4.4410 7.9977 4.0366 15.5535 4.9114 17.3812 10.2745 3.2998 5.6457 18.3290 5.5010 10.5431 7.7655 9.1096 7.9284 8.5656 10.1965
CT 0.0000 4.1868 13.5257 2.6667 6.7048 9.8789 11.3014 8.3169 4.0266 4.0878 9.0903 13.8542 31.6306 8.1235 7.4090 5.3916 10.6401 3.1383 5.3041 9.9019 13.2467
DC 0.0000 8.4433 10.3489 0.0000 3.0000 2.3854 4.3223 4.3995 8.1224 3.1890 6.5814 11.9768 6.6064 3.7701 24.0549 5.0723 6.5763 3.7222 3.5901 7.4984 5.5125
DE 0.0000 50.5187 6.4003 0.0000 4.4296 0.7625 4.4799 14.1210 6.9528 10.9468 4.4106 8.0913 5.2344 59.5415 12.7233 9.5342 8.8610 14.0637 7.6462 8.8041 11.7910
FL 7.2033 9.1914 9.1371 6.6163 6.1110 6.5198 7.3927 8.0158 8.4556 9.1168 7.9884 8.7404 9.1507 9.0282 10.9026 8.9050 9.6044 10.2090 9.7653 10.2058 9.9579
GA 0.0000 15.7238 9.4611 10.9593 12.5521 9.2004 9.5964 9.1867 9.4389 13.1777 16.2498 9.2498 9.1894 9.1007 11.9152 12.5995 8.8939 12.3302 11.9475 11.3177 12.8807
HI 0.0000 5.0395 11.1333 1.4439 7.5685 8.5570 8.6896 3.6169 7.3063 6.8270 4.5733 2.5239 5.7533 3.8256 5.3664 3.2286 7.1706 6.0068 6.3465 5.5635 6.8842
IA 3.0000 6.5208 10.0158 30.3062 8.3122 6.3517 5.6331 7.3669 6.9069 9.4469 7.7191 12.0419 7.5997 9.5535 8.0617 6.5388 6.7256 8.4385 9.9307 8.5020 9.9264
ID 3.4016 6.0063 12.6751 16.9791 3.9715 5.7593 7.0389 31.7611 8.3222 8.4325 6.0079 7.3135 11.5646 10.5898 9.5543 2.6258 4.8426 6.5571 7.3930 6.6206 7.8888
IL 0.0000 6.6053 7.6677 4.2159 8.3825 3.6322 12.4091 7.0132 6.4036 7.3215 5.5886 6.0817 7.1897 7.6229 8.4978 7.1650 8.0793 7.1840 9.2014 9.7325 9.3598
IN 0.0000 6.4646 7.3909 5.9286 7.2406 7.0505 5.5475 6.6873 8.3576 7.5172 9.9274 8.8012 8.1994 9.0986 8.9586 8.0587 11.0063 9.3285 9.0443 10.9217 10.7146
KS 0.0000 18.4954 4.1250 1.0168 2.8712 9.3264 6.2646 38.2337 4.6307 4.8312 10.3218 4.0665 5.3968 6.8686 11.4034 4.4843 20.3446 5.3957 4.5577 14.6528 12.2108
KY 0.0000 10.1980 5.7776 10.9922 13.9300 16.5340 8.3153 5.9722 11.8980 7.4411 8.9091 20.9760 8.9830 13.2109 8.6736 19.0252 10.4644 8.6407 6.6519 7.7591 8.5107
LA 0.0000 5.0095 11.5223 2.2463 6.4596 10.7457 4.4312 4.6940 9.2008 5.9482 5.3175 4.4399 10.1942 9.7410 8.7033 14.3867 8.7391 10.3232 17.6573 16.5281 14.9957
MA 0.0000 4.0833 9.7099 5.8983 14.8289 5.9640 4.4539 4.2199 7.1168 10.1197 11.8155 7.8150 10.9009 5.6638 6.2611 23.1748 7.9996 11.2395 15.0721 15.0483 11.1532
MD 0.0000 8.5427 13.6245 1.8519 6.9625 1.7809 5.1645 6.0790 18.1198 8.0536 11.9931 6.8660 14.4037 6.4574 7.9682 10.8011 13.3939 5.6741 17.6171 10.5729 14.8895
ME 0.0000 7.7754 3.2083 0.2222 7.8534 8.8337 8.9394 6.5832 4.9920 4.6855 9.6736 17.8201 10.6318 18.6272 16.3436 5.3350 5.4655 9.3668 15.4956 12.3133 8.6186
MI 0.0000 11.0243 15.3822 6.1228 4.2801 6.0489 6.8643 7.8136 5.4496 10.0197 6.9515 6.8965 12.7939 4.9193 8.7550 13.4944 7.8040 5.1189 9.0210 11.3258 8.6800
MN 0.0000 2.1474 6.4553 4.2520 4.5376 2.2905 5.6659 4.2519 9.5218 9.0932 5.3617 9.8684 9.5411 10.9148 9.9892 4.3567 7.3277 15.1589 7.9707 8.5595 12.1282
MO 0.0000 3.1232 9.8763 0.0000 10.6528 10.9799 15.2261 13.3868 5.6478 8.1963 5.5982 10.5745 8.7684 4.2235 7.6873 10.1486 10.1066 8.5832 10.0387 9.1907 17.3607
MS 0.0000 5.8456 4.7428 21.5445 11.2585 8.3016 17.2245 8.5572 6.6141 14.1638 8.0847 103.6009 10.5150 37.2763 10.0150 6.0359 6.9634 22.2836 20.0459 6.8151 11.9442
MT 0.0000 4.0572 8.2897 3.6685 0.9206 4.1657 14.2916 6.3656 5.3687 8.4202 26.1168 5.8988 6.5863 9.7086 9.8946 7.4359 19.6896 12.6768 6.5269 9.6484 26.9798
NC 10.0000 6.2550 8.9589 6.0982 8.1016 8.6577 8.8186 9.6854 9.7957 9.2454 9.2717 12.8170 11.1220 10.1203 11.2256 9.9604 11.6255 13.9336 11.8257 10.6951 11.5034
ND 4.5000 0.6667 4.7726 8.9831 3.5694 9.8632 9.1720 3.7327 6.2366 4.2980 3.6801 7.5803 10.9094 6.2307 6.8728 2.4152 15.8942 17.7348 16.6316 8.9371 5.7216
NE 6.5660 8.8191 6.4454 8.1993 6.6960 7.0680 4.9266 7.8100 12.3171 7.5380 8.3981 9.6753 8.5493 6.5478 13.6453 6.3738 9.8366 12.4340 7.4366 11.3192 10.0474
NH 0.0000 2.2593 11.1807 1.4209 6.4766 8.2386 8.4760 5.7842 8.2985 17.5550 14.4369 13.3610 18.0320 9.9693 7.8926 6.4387 10.6572 7.8865 10.2263 10.8490 12.3625
NJ 0.0000 7.9881 9.1182 3.3875 3.3333 262.8067 2.5313 8.5121 6.2691 4.3036 6.7950 7.1482 11.4965 10.3294 13.3344 6.5336 6.9988 12.7355 13.4452 8.0273 10.4469
NM 0.0000 2.7280 13.0181 23.1865 5.2640 6.1161 2.5720 5.4144 7.2209 5.6762 6.8490 10.0465 15.1832 28.2829 7.8088 4.5383 3.1193 7.3126 5.3984 8.2497 19.1609
NV 0.0000 8.0444 5.8762 3.2500 11.6877 4.3373 4.4893 2.7401 7.3786 6.4491 6.3839 8.7265 11.8404 11.7382 7.0077 36.4788 8.5003 9.2080 6.2107 7.7584 10.8052
NY 6.8704 6.5187 8.6748 12.5151 5.8043 6.1318 7.5479 6.9818 6.8410 7.6337 7.8156 6.8407 9.8649 7.4193 8.4316 8.5553 8.9231 14.9466 8.5221 8.4554 9.4272
OH 0.0000 33.6085 27.1134 1.6191 9.6160 9.5768 5.3853 9.7222 9.5231 20.4840 9.3050 9.8026 6.6659 27.9566 7.8051 9.0384 9.6530 14.6686 11.0625 12.2542 7.3503
OK 0.0000 6.4254 28.1849 16.9093 14.2566 9.1205 6.7927 7.2364 7.5292 9.7217 6.3139 10.3085 7.8289 18.0822 3.8643 9.0324 3.0611 5.6391 11.4973 8.9363 12.2854
OR 0.0000 4.4222 6.5150 0.5556 2.7900 3.5151 6.0604 17.0545 4.4118 4.9109 7.0725 10.5935 7.7010 6.5596 5.6485 23.0060 9.1089 14.7325 4.4128 7.2134 8.1598
PA 4.2724 4.6536 10.9572 8.0693 10.2926 7.5329 8.6098 6.1705 5.7408 10.1664 5.9283 7.4869 13.9561 10.7881 10.8508 10.2243 10.3891 7.1990 8.8464 12.5702 10.0487
RI 0.0000 3.2832 7.4096 0.0000 56.7634 2.9603 3.3112 4.0348 3.9528 3.9538 7.1987 2.0463 5.2759 7.6762 9.3750 17.8533 2.0497 6.8556 9.8391 11.7035 11.5140
SC 8.8730 9.1928 9.0483 6.2046 6.3214 9.6374 11.0878 9.3678 10.5364 12.7906 9.6516 7.9806 9.9618 9.8489 9.2276 13.8016 11.9901 10.3631 12.4002 11.2115 10.3298
SD 2.0000 8.0030 21.3545 9.4321 4.2393 2.8135 4.2628 18.9588 9.9843 8.0735 7.0688 8.7537 7.9029 10.6755 9.8901 5.5056 6.7612 10.4256 5.3584 6.4111 10.7663
TN 0.2222 6.6380 16.5333 7.2052 6.7597 6.5601 8.2283 11.9356 10.9718 11.6906 9.9551 13.3103 9.0375 13.4982 10.6205 12.8168 14.0690 10.5271 11.9017 9.9185 10.8957
TX 8.1459 10.8888 11.6670 7.4577 8.1177 9.1266 8.2685 8.5910 8.0932 9.4565 8.4322 10.2108 8.7350 10.2003 11.3832 10.8093 9.7822 9.7075 11.5267 11.0154 11.1365
UT 0.0000 7.7915 3.2061 16.7416 0.0000 3.7229 8.2743 9.5167 33.1498 1.7287 4.0551 10.6927 6.7825 7.1244 5.8736 7.8082 4.2967 6.6708 8.8819 8.6688 7.3493
VA 5.6891 10.6051 10.1814 10.8780 8.7703 8.7579 10.7496 9.0254 9.4091 11.4759 10.7410 9.4328 9.6033 9.7994 9.0434 9.4621 11.1173 9.5568 11.1305 10.1877 10.0743
VT 8.7143 5.1364 10.2969 22.3570 6.7345 9.6337 6.0779 7.1504 7.4487 9.9361 11.7653 7.4199 7.8429 11.6723 11.6894 10.7960 11.2696 11.1435 10.9076 10.1618 10.4590
WA 0.0000 3.6230 16.8673 7.9466 2.8646 9.9742 6.0416 6.7809 4.7221 22.0090 10.2386 7.3690 8.3343 6.7718 14.3258 3.9635 7.9939 6.7342 6.9491 10.4722 9.1177
WI 0.0000 8.2163 6.9116 19.1345 6.6401 7.4065 10.0250 6.4420 7.8819 14.4299 8.1153 8.4286 8.6607 11.1477 9.6775 13.3483 10.8149 10.2514 10.0787 10.6085 10.2501
WV 0.0000 7.2415 6.0528 7.3011 6.7213 7.5823 8.9582 12.9597 13.1620 10.9161 11.2057 12.5817 7.9540 12.7558 20.1805 15.9753 14.5605 5.7276 10.7585 16.7615 12.3385
WY 0.0000 0.0000 3.1706 0.6190 2.9580 1.7193 2.6533 5.3132 7.4934 8.2084 10.7206 5.9978 4.6181 11.9584 8.7587 5.0098 8.0880 19.3201 4.4484 10.5897 11.1173
Sum 95.7996 408.7472 512.2712 397.4375 448.9869 604.9351 374.8812 461.3787 439.3202 459.8650 446.6050 559.5623 487.9338 586.9651 501.2371 508.2172 473.3165 494.8145 496.0490 518.9352 556.5798

4. HTML table with both row and column totals

make_contingency_table(ex3, show_variance = F) %>%
  add_totals(margin = 1:2) %>%
  format_table %>% 
  make_html_table
HHFAMINC -9 -8 -7 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Sum
HHSTATE
AK 0.0000 7.6415 9.7611 0.0000 8.6710 3.0614 6.9532 3.6749 16.0907 4.6921 5.4653 4.5613 6.7338 2.7192 5.1440 2.8301 4.5102 5.3279 7.2795 8.2586 6.4716 119.8476
AL 0.0000 7.5301 11.5908 14.0406 34.4716 3.7726 9.6009 17.7478 9.4484 11.8305 12.4375 18.1849 9.4145 4.4484 11.1167 9.6416 11.7801 6.1230 14.1704 10.4900 10.3939 238.2343
AR 0.0000 7.0380 9.0933 10.4454 16.5966 7.2315 6.0990 3.8017 10.1404 8.5753 8.9612 9.5662 9.4126 9.8041 7.9410 18.4542 9.9558 7.9804 7.8885 9.4726 13.1849 191.6426
AZ 0.0000 2.9468 7.3169 6.9776 18.7289 6.9391 4.4152 5.7754 8.7257 6.0261 11.3939 9.8182 9.0141 7.8668 14.8468 9.8119 8.6402 6.8135 9.3846 17.9475 8.3395 181.7287
CA 16.3414 8.5543 8.1510 10.3712 8.4714 8.0044 7.2037 7.2628 8.7828 7.6730 8.3936 8.0233 9.0212 8.7788 9.1168 9.3935 9.4056 8.3065 8.8770 9.7435 9.6913 189.5671
CO 0.0000 3.0250 12.3733 9.2000 4.4410 7.9977 4.0366 15.5535 4.9114 17.3812 10.2745 3.2998 5.6457 18.3290 5.5010 10.5431 7.7655 9.1096 7.9284 8.5656 10.1965 176.0784
CT 0.0000 4.1868 13.5257 2.6667 6.7048 9.8789 11.3014 8.3169 4.0266 4.0878 9.0903 13.8542 31.6306 8.1235 7.4090 5.3916 10.6401 3.1383 5.3041 9.9019 13.2467 182.4259
DC 0.0000 8.4433 10.3489 0.0000 3.0000 2.3854 4.3223 4.3995 8.1224 3.1890 6.5814 11.9768 6.6064 3.7701 24.0549 5.0723 6.5763 3.7222 3.5901 7.4984 5.5125 129.1724
DE 0.0000 50.5187 6.4003 0.0000 4.4296 0.7625 4.4799 14.1210 6.9528 10.9468 4.4106 8.0913 5.2344 59.5415 12.7233 9.5342 8.8610 14.0637 7.6462 8.8041 11.7910 249.3126
FL 7.2033 9.1914 9.1371 6.6163 6.1110 6.5198 7.3927 8.0158 8.4556 9.1168 7.9884 8.7404 9.1507 9.0282 10.9026 8.9050 9.6044 10.2090 9.7653 10.2058 9.9579 182.2175
GA 0.0000 15.7238 9.4611 10.9593 12.5521 9.2004 9.5964 9.1867 9.4389 13.1777 16.2498 9.2498 9.1894 9.1007 11.9152 12.5995 8.8939 12.3302 11.9475 11.3177 12.8807 224.9708
HI 0.0000 5.0395 11.1333 1.4439 7.5685 8.5570 8.6896 3.6169 7.3063 6.8270 4.5733 2.5239 5.7533 3.8256 5.3664 3.2286 7.1706 6.0068 6.3465 5.5635 6.8842 117.4245
IA 3.0000 6.5208 10.0158 30.3062 8.3122 6.3517 5.6331 7.3669 6.9069 9.4469 7.7191 12.0419 7.5997 9.5535 8.0617 6.5388 6.7256 8.4385 9.9307 8.5020 9.9264 188.8984
ID 3.4016 6.0063 12.6751 16.9791 3.9715 5.7593 7.0389 31.7611 8.3222 8.4325 6.0079 7.3135 11.5646 10.5898 9.5543 2.6258 4.8426 6.5571 7.3930 6.6206 7.8888 185.3057
IL 0.0000 6.6053 7.6677 4.2159 8.3825 3.6322 12.4091 7.0132 6.4036 7.3215 5.5886 6.0817 7.1897 7.6229 8.4978 7.1650 8.0793 7.1840 9.2014 9.7325 9.3598 149.3538
IN 0.0000 6.4646 7.3909 5.9286 7.2406 7.0505 5.5475 6.6873 8.3576 7.5172 9.9274 8.8012 8.1994 9.0986 8.9586 8.0587 11.0063 9.3285 9.0443 10.9217 10.7146 166.2442
KS 0.0000 18.4954 4.1250 1.0168 2.8712 9.3264 6.2646 38.2337 4.6307 4.8312 10.3218 4.0665 5.3968 6.8686 11.4034 4.4843 20.3446 5.3957 4.5577 14.6528 12.2108 189.4981
KY 0.0000 10.1980 5.7776 10.9922 13.9300 16.5340 8.3153 5.9722 11.8980 7.4411 8.9091 20.9760 8.9830 13.2109 8.6736 19.0252 10.4644 8.6407 6.6519 7.7591 8.5107 212.8631
LA 0.0000 5.0095 11.5223 2.2463 6.4596 10.7457 4.4312 4.6940 9.2008 5.9482 5.3175 4.4399 10.1942 9.7410 8.7033 14.3867 8.7391 10.3232 17.6573 16.5281 14.9957 181.2834
MA 0.0000 4.0833 9.7099 5.8983 14.8289 5.9640 4.4539 4.2199 7.1168 10.1197 11.8155 7.8150 10.9009 5.6638 6.2611 23.1748 7.9996 11.2395 15.0721 15.0483 11.1532 192.5385
MD 0.0000 8.5427 13.6245 1.8519 6.9625 1.7809 5.1645 6.0790 18.1198 8.0536 11.9931 6.8660 14.4037 6.4574 7.9682 10.8011 13.3939 5.6741 17.6171 10.5729 14.8895 190.8166
ME 0.0000 7.7754 3.2083 0.2222 7.8534 8.8337 8.9394 6.5832 4.9920 4.6855 9.6736 17.8201 10.6318 18.6272 16.3436 5.3350 5.4655 9.3668 15.4956 12.3133 8.6186 182.7842
MI 0.0000 11.0243 15.3822 6.1228 4.2801 6.0489 6.8643 7.8136 5.4496 10.0197 6.9515 6.8965 12.7939 4.9193 8.7550 13.4944 7.8040 5.1189 9.0210 11.3258 8.6800 168.7659
MN 0.0000 2.1474 6.4553 4.2520 4.5376 2.2905 5.6659 4.2519 9.5218 9.0932 5.3617 9.8684 9.5411 10.9148 9.9892 4.3567 7.3277 15.1589 7.9707 8.5595 12.1282 149.3927
MO 0.0000 3.1232 9.8763 0.0000 10.6528 10.9799 15.2261 13.3868 5.6478 8.1963 5.5982 10.5745 8.7684 4.2235 7.6873 10.1486 10.1066 8.5832 10.0387 9.1907 17.3607 179.3697
MS 0.0000 5.8456 4.7428 21.5445 11.2585 8.3016 17.2245 8.5572 6.6141 14.1638 8.0847 103.6009 10.5150 37.2763 10.0150 6.0359 6.9634 22.2836 20.0459 6.8151 11.9442 341.8327
MT 0.0000 4.0572 8.2897 3.6685 0.9206 4.1657 14.2916 6.3656 5.3687 8.4202 26.1168 5.8988 6.5863 9.7086 9.8946 7.4359 19.6896 12.6768 6.5269 9.6484 26.9798 196.7103
NC 10.0000 6.2550 8.9589 6.0982 8.1016 8.6577 8.8186 9.6854 9.7957 9.2454 9.2717 12.8170 11.1220 10.1203 11.2256 9.9604 11.6255 13.9336 11.8257 10.6951 11.5034 209.7169
ND 4.5000 0.6667 4.7726 8.9831 3.5694 9.8632 9.1720 3.7327 6.2366 4.2980 3.6801 7.5803 10.9094 6.2307 6.8728 2.4152 15.8942 17.7348 16.6316 8.9371 5.7216 158.4022
NE 6.5660 8.8191 6.4454 8.1993 6.6960 7.0680 4.9266 7.8100 12.3171 7.5380 8.3981 9.6753 8.5493 6.5478 13.6453 6.3738 9.8366 12.4340 7.4366 11.3192 10.0474 180.6486
NH 0.0000 2.2593 11.1807 1.4209 6.4766 8.2386 8.4760 5.7842 8.2985 17.5550 14.4369 13.3610 18.0320 9.9693 7.8926 6.4387 10.6572 7.8865 10.2263 10.8490 12.3625 191.8019
NJ 0.0000 7.9881 9.1182 3.3875 3.3333 262.8067 2.5313 8.5121 6.2691 4.3036 6.7950 7.1482 11.4965 10.3294 13.3344 6.5336 6.9988 12.7355 13.4452 8.0273 10.4469 415.5408
NM 0.0000 2.7280 13.0181 23.1865 5.2640 6.1161 2.5720 5.4144 7.2209 5.6762 6.8490 10.0465 15.1832 28.2829 7.8088 4.5383 3.1193 7.3126 5.3984 8.2497 19.1609 187.1457
NV 0.0000 8.0444 5.8762 3.2500 11.6877 4.3373 4.4893 2.7401 7.3786 6.4491 6.3839 8.7265 11.8404 11.7382 7.0077 36.4788 8.5003 9.2080 6.2107 7.7584 10.8052 178.9108
NY 6.8704 6.5187 8.6748 12.5151 5.8043 6.1318 7.5479 6.9818 6.8410 7.6337 7.8156 6.8407 9.8649 7.4193 8.4316 8.5553 8.9231 14.9466 8.5221 8.4554 9.4272 174.7213
OH 0.0000 33.6085 27.1134 1.6191 9.6160 9.5768 5.3853 9.7222 9.5231 20.4840 9.3050 9.8026 6.6659 27.9566 7.8051 9.0384 9.6530 14.6686 11.0625 12.2542 7.3503 252.2108
OK 0.0000 6.4254 28.1849 16.9093 14.2566 9.1205 6.7927 7.2364 7.5292 9.7217 6.3139 10.3085 7.8289 18.0822 3.8643 9.0324 3.0611 5.6391 11.4973 8.9363 12.2854 203.0262
OR 0.0000 4.4222 6.5150 0.5556 2.7900 3.5151 6.0604 17.0545 4.4118 4.9109 7.0725 10.5935 7.7010 6.5596 5.6485 23.0060 9.1089 14.7325 4.4128 7.2134 8.1598 154.4439
PA 4.2724 4.6536 10.9572 8.0693 10.2926 7.5329 8.6098 6.1705 5.7408 10.1664 5.9283 7.4869 13.9561 10.7881 10.8508 10.2243 10.3891 7.1990 8.8464 12.5702 10.0487 184.7535
RI 0.0000 3.2832 7.4096 0.0000 56.7634 2.9603 3.3112 4.0348 3.9528 3.9538 7.1987 2.0463 5.2759 7.6762 9.3750 17.8533 2.0497 6.8556 9.8391 11.7035 11.5140 177.0562
SC 8.8730 9.1928 9.0483 6.2046 6.3214 9.6374 11.0878 9.3678 10.5364 12.7906 9.6516 7.9806 9.9618 9.8489 9.2276 13.8016 11.9901 10.3631 12.4002 11.2115 10.3298 209.8268
SD 2.0000 8.0030 21.3545 9.4321 4.2393 2.8135 4.2628 18.9588 9.9843 8.0735 7.0688 8.7537 7.9029 10.6755 9.8901 5.5056 6.7612 10.4256 5.3584 6.4111 10.7663 178.6407
TN 0.2222 6.6380 16.5333 7.2052 6.7597 6.5601 8.2283 11.9356 10.9718 11.6906 9.9551 13.3103 9.0375 13.4982 10.6205 12.8168 14.0690 10.5271 11.9017 9.9185 10.8957 213.2953
TX 8.1459 10.8888 11.6670 7.4577 8.1177 9.1266 8.2685 8.5910 8.0932 9.4565 8.4322 10.2108 8.7350 10.2003 11.3832 10.8093 9.7822 9.7075 11.5267 11.0154 11.1365 202.7521
UT 0.0000 7.7915 3.2061 16.7416 0.0000 3.7229 8.2743 9.5167 33.1498 1.7287 4.0551 10.6927 6.7825 7.1244 5.8736 7.8082 4.2967 6.6708 8.8819 8.6688 7.3493 162.3355
VA 5.6891 10.6051 10.1814 10.8780 8.7703 8.7579 10.7496 9.0254 9.4091 11.4759 10.7410 9.4328 9.6033 9.7994 9.0434 9.4621 11.1173 9.5568 11.1305 10.1877 10.0743 205.6903
VT 8.7143 5.1364 10.2969 22.3570 6.7345 9.6337 6.0779 7.1504 7.4487 9.9361 11.7653 7.4199 7.8429 11.6723 11.6894 10.7960 11.2696 11.1435 10.9076 10.1618 10.4590 208.6133
WA 0.0000 3.6230 16.8673 7.9466 2.8646 9.9742 6.0416 6.7809 4.7221 22.0090 10.2386 7.3690 8.3343 6.7718 14.3258 3.9635 7.9939 6.7342 6.9491 10.4722 9.1177 173.0992
WI 0.0000 8.2163 6.9116 19.1345 6.6401 7.4065 10.0250 6.4420 7.8819 14.4299 8.1153 8.4286 8.6607 11.1477 9.6775 13.3483 10.8149 10.2514 10.0787 10.6085 10.2501 198.4697
WV 0.0000 7.2415 6.0528 7.3011 6.7213 7.5823 8.9582 12.9597 13.1620 10.9161 11.2057 12.5817 7.9540 12.7558 20.1805 15.9753 14.5605 5.7276 10.7585 16.7615 12.3385 221.6945
WY 0.0000 0.0000 3.1706 0.6190 2.9580 1.7193 2.6533 5.3132 7.4934 8.2084 10.7206 5.9978 4.6181 11.9584 8.7587 5.0098 8.0880 19.3201 4.4484 10.5897 11.1173 132.7623
Sum 95.7996 408.7472 512.2712 397.4375 448.9869 604.9351 374.8812 461.3787 439.3202 459.8650 446.6050 559.5623 487.9338 586.9651 501.2371 508.2172 473.3165 494.8145 496.0490 518.9352 556.5798 9833.8381

Creating Interactive Maps

library(ggplot2)
library(ggiraph)
library(geojsonio)
source("map(functions).R")

nation_layer <- geojson_read("./resources/geography/cb_2015_us_nation_20m(composite).geojson", what = "sp")
nation_layer <- fortify_spatial_data_frame(nation_layer, "id")

state_layer <- geojson_read("./resources/geography/cb_2015_us_state_20m(composite).geojson", what = "sp")
state_layer <- fortify_spatial_data_frame(state_layer, "id")
tbl1 <- make_table(
  data = dt, 
  agg = 'sum',
  agg_var = 'VMT_MILE',
  factors = 'HHSTATE',
  wgt_name = 'DAYWGT',
  subset = 'VMT_MILE >= 0'
)

tbl2 <- make_table(
  data = dt, 
  agg = 'sum',
  agg_var = 'VMT_MILE',
  factors = c('HHSTATE','HHFAMINC'),
  wgt_name = 'DAYWGT',
  subset = 'VMT_MILE >= 0'
)


gg_list <- lapply(split(tbl2, tbl2$HHSTATE), function(x) {
  
  g <- ggplot(x, aes(x=factor(HHFAMINC), y=VMT_MILE))
  g <- g + geom_bar(stat="identity")
  g <- g + geom_errorbar(aes(ymax = VMT_MILE + se, ymin = VMT_MILE - se), width = 0.25)
  g <- g + labs(x = 'Derived total HH income', y = 'Calculated Trip distance (miles) for Driver Trips')
  g <- g + theme_light()
  g <- ggiraph(code = {print(g)})
  gsub("'", "\"", g$x$html)
  
})

gg_html <- unlist(gg_list)
gg_html <- cbind(STUSPS = attr(gg_html, "names"), tooltip = gg_html)

merged <- merge(x = state_layer, y = tbl1, by.x = 'STUSPS', by.y = 'HHSTATE')
merged <- merge(merged, gg_html, by = 'STUSPS')


geom_nation_layer <- geom_polygon(
  data = nation_layer,
  mapping = aes(
    x = long,
    y = lat,
    group = group),
  fill = "#DDDDDD")

geom_state_layer <- geom_polygon_interactive(
  data = merged,
  mapping = aes(
    x = long,
    y = lat,
    group = group,
    tooltip = paste0(STUSPS, '<br>', tooltip),
    fill = VMT_MILE,
    use_jquery = TRUE,
    data_id = STATEFP,
    hover_css = "fill:orange"),
  color = "#FFFFFF",
  size = 0.35)
## Warning: Ignoring unknown aesthetics: tooltip, use_jquery, data_id,
## hover_css
map <- ggplot()
map <- map + geom_nation_layer
map <- map + geom_state_layer
map <- map + coord_fixed()
map <- map + theme_void()
map <- map + scale_fill_gradient(low = "#f2f0f7", high = "#54278f")
map_widget <- ggiraph(code = {print(map)}, zoom_max = 12)
map_widget